from pysqlite2 import dbapi2 as sqlite3

conn = sqlite3.connect('c:\\tmp\\example')

# Crea un cursore che segue la connessione
cur = conn.cursor()
# comandi sql
cur.execute('drop table card')
cur.execute('create table card (id integer primary key autoincrement, question varchar(255), answer varchar2(255), next_date date default CURRENT_DATE, iteration integer default 1)')
cur.execute("insert into card (question,answer) values ('question', 'answer')")
cur.execute("insert into distro2 (question,answer) values ('question2', 'answer2')")
conn.commit()

cur.execute('select * from card')
for (id, question, solution, next_date) in cur:
    print 'id = %d text= %s' % (id, text)
    
cur.close()
conn.close()